OpenUtilities Substation Help

Import Validation

Data in the selected JSON import file is validated and compared to data in the active project prior to the completion of the import process. A Waring dialog will appear when the JSON file contains one or more devices which exist in active project. This is required to prevent duplication of devices. Refer to Import Warning dialog for specific details.

Conditions & Special Handling

Note: Refer to BOM JSON File Format for detailed information regarding JSON Objects.
  • Data Eligible for import.
    1. BOM Document properties - JSON Object Documents
    2. BM Data user fields – JSON Object BomItems
    3. Device Properties for device records without association to symbols – JSON Objects Devices & NameplateDevices where SymbolAssociation property equals false.
    4. Nameplate symbol text for JSON Object NameplateDevices
    5. SAP BOM Submission data – JSON Object BomSubmits
  • Special Handling
    1. Device Tags beginning with TEMP are renamed using next available sequence number in active project.

      Example Scenario:

      Export BOM to JSON file from Project #1. Then import JSON file into Project #2.

      Conditions
      • Project #1 – JSON export contains TEMP Device “TEMP119”

      • Project #2 – Highest TEMP device in this project is “TEMP21”.

      Result

      Data for Balloon number 98 imported and Device Tag changed to TEMP22.

    2. Custom Part numbers beginning with NC are renamed using next available sequence number in active project.

      Example Scenario:

      Export BOM to JSON file from Project #1. Then import JSON file into Project #2

      Conditions
      • Project #1 – JSON export contains Custom Part Number “NC00001”.

      • Project #2 - Highest Custom NC Part Number in this project is “NC00001”.

      Result

      Data for Balloon number 132 imported and Part Number changed to NC00002.